﻿<%@ Page Language="C#" AutoEventWireup="true" Theme="Default" CodeBehind="ZhiDingQJCX.aspx.cs" Inherits="Web.Pages.QuShui.DiXiaS._7.ChaXunGL.ZhiDingQJCX" %>

<%@ Register Assembly="DevExpress.Web.v15.2, Version=15.2.9.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" Namespace="DevExpress.Web" TagPrefix="dx" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <title>指定年月区间查询</title>
    <script src="../../../../JS/jquery.js" type="text/javascript"></script>
    <script src="../../../../JS/AddEditCancel.js" type="text/javascript"></script>
    <link href="../../../../css/inputBgColor.css" rel="stylesheet" />
    <style type="text/css">
        body, html {
            padding: 0;
            margin: 0;
            font-size: 12px;
        }

        #img table tr td div {
            cursor: pointer;
        }
    </style>
    <script type="text/javascript">
        $(function () {
            var height = Math.max(0, document.documentElement.clientHeight) - 90;
            // $("#condition").css("height", height);
        });




    </script>
</head>
<body>
    <form id="form1" runat="server">

        <asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager>
        <div>
            <div class="tabletitle1" align="center">
                指定年月区间查询
            </div>
            <div style="display: none;">
                <dx:ASPxHiddenField ID="hdCollection" ClientInstanceName="hdCollection" runat="server"></dx:ASPxHiddenField>
                <dx:ASPxCallback ID="ASPxCallback1" ClientInstanceName="ASPxCallback1" runat="server" OnCallback="ASPxCallback1_Callback" ClientSideEvents-CallbackComplete="function(s,e){ASPxCallback1Complete(e.result);}"></dx:ASPxCallback>
            </div>

            <asp:UpdatePanel ID="updatePanel1" runat="server">
                <ContentTemplate>
                    <div>
                        <table style="width: 98%; margin: 0px auto">
                            <tr>
                                <td colspan="2" rowspan="5" style="min-width: 200px; width: 20%;" valign="top">
                                    <table style="width: 100%">
                                        <tr>
                                            <td valign="top">
                                                <fieldset style="border: 1px solid #d0e4fe">
                                                    <legend>查询条件</legend>
                                                    <table style="height: 270px; width: 98%;">
                                                        <tr>
                                                            <td align="right" style="min-width: 80px">开始水量年：</td>
                                                            <td>
                                                                <asp:Panel runat="server" ID="Panel7">
                                                                    <dx:ASPxComboBox runat="server" ID="cmbYear" Width="100%">
                                                                    </dx:ASPxComboBox>
                                                                </asp:Panel>
                                                            </td>
                                                        </tr>
                                                        <tr>
                                                            <td align="right">开始水量月：</td>
                                                            <td>
                                                                <asp:Panel runat="server" ID="Panel8">
                                                                    <dx:ASPxComboBox runat="server" ID="cmbMonth" Width="100%">
                                                                    </dx:ASPxComboBox>
                                                                </asp:Panel>

                                                            </td>
                                                        </tr>
                                                        <tr>
                                                            <td align="right" style="min-width: 80px">结束水量年：</td>
                                                            <td>
                                                                <asp:Panel runat="server" ID="Panel6">
                                                                    <dx:ASPxComboBox runat="server" ID="cmbYear1" Width="100%">
                                                                    </dx:ASPxComboBox>
                                                                </asp:Panel>
                                                            </td>
                                                        </tr>
                                                        <tr>
                                                            <td align="right">结束水量月：</td>
                                                            <td>
                                                                <asp:Panel runat="server" ID="Panel9">
                                                                    <dx:ASPxComboBox runat="server" ID="cmbMonth1" Width="100%">
                                                                    </dx:ASPxComboBox>
                                                                </asp:Panel>

                                                            </td>
                                                        </tr>
                                                        <tr>
                                                            <td style="width: 80px" align="right">用户号：
                                                            </td>
                                                            <td>
                                                                <dx:ASPxTextBox runat="server" ID="txtYongHuH" Width="100%">
                                                                </dx:ASPxTextBox>
                                                            </td>
                                                        </tr>

                                                        <tr>
                                                            <td align="right">用户名：
                                                            </td>
                                                            <td>
                                                                <dx:ASPxTextBox runat="server" ID="txtYongHuM" Width="100%">
                                                                </dx:ASPxTextBox>
                                                            </td>
                                                        </tr>

                                                        <tr>
                                                            <td align="right">取水用途：
                                                            </td>
                                                            <td>
                                                                <dx:ASPxComboBox ID="cmbQuShuiYT" ClientInstanceName="cmbQuShuiYT" runat="server" ValueType="System.String" Width="100%">
                                                                </dx:ASPxComboBox>
                                                            </td>
                                                        </tr>
                                                        <tr>
                                                            <tr>
                                                                <td align="right">行业分类：
                                                                </td>
                                                                <td>
                                                                    <dx:ASPxComboBox ID="cmbHangYeLX" ClientInstanceName="cmbHangYeLX" runat="server" ValueType="System.String" Width="100%">
                                                                    </dx:ASPxComboBox>
                                                                </td>
                                                            </tr>

                                                            <tr>
                                                                <td style="width: 8%" align="right"><span style="font-size: 12px;">环内环外：</span></td>
                                                                <td style="width: 15%">
                                                                    <asp:Panel runat="server" ID="Panel1">
                                                                        <dx:ASPxComboBox runat="server" ID="cmbHuanNeiHW" Width="100%" AutoPostBack="false">
                                                                            <Items>
                                                                                <dx:ListEditItem Text="" Value="" />
                                                                                <dx:ListEditItem Text="外环线内" Value="1" />
                                                                                <dx:ListEditItem Text="外环线外" Value="2" />
                                                                            </Items>
                                                                        </dx:ASPxComboBox>
                                                                    </asp:Panel>
                                                                </td>
                                                            </tr>
                                                            <tr>
                                                                <td style="width: 8%;" align="right"><span style="font-size: 12px;">行政区：</span></td>
                                                                <td style="width: 15%">
                                                                    <asp:Panel runat="server" ID="Panel2">
                                                                        <dx:ASPxComboBox runat="server" ID="cmbXingZhengQ" Width="100%">
                                                                            <Items>
                                                                                <dx:ListEditItem Text="全部" Value="" Selected="true" />
                                                                            </Items>
                                                                        </dx:ASPxComboBox>
                                                                    </asp:Panel>
                                                                </td>
                                                            </tr>

                                                            <tr>
                                                                <td colspan="6" align="center">
                                                                    <br />
                                                                    <br />
                                                                    <dx:ASPxLoadingPanel runat="server" ID="LoadPanel11" ClientInstanceName="LoadPanel" Text="正在查询"></dx:ASPxLoadingPanel>
                                                                    <dx:ASPxButton runat="server" ID="btnChaXun" Text="查询" OnClick="btnChaXun_Click" UseSubmitBehavior="false">
                                                                        <ClientSideEvents Click="function(s,e){LoadPanel.Show();}" />
                                                                    </dx:ASPxButton>
                                                                    <dx:ASPxButton ID="btnExport2" runat="server" Text="导出EXCEL">
                                                                        <ClientSideEvents Click="function(s,e){btnExport.OnClick();}" />
                                                                    </dx:ASPxButton>

                                                                </td>
                                                            </tr>
                                                    </table>
                                                </fieldset>
                                            </td>
                                        </tr>
                                    </table>
                                </td>
                                <tr>
                                    <td colspan="6" valign="top">
                                        <div style="border: 1px solid #d0e4fe; width: 100%;">
                                            
                    
                                            <div>
                                                <dx:ASPxGridView ID="gvShenJingXX" SettingsBehavior-AllowSort="true" ClientInstanceName="gvShenJingXX" runat="server" AutoGenerateColumns="False" KeyFieldName="用户号"
                                                    ClientIDMode="AutoID" Settings-ShowVerticalScrollBar="true" Width="100%" EnableCallBacks="true">
                                                    <Columns>

                                                        <dx:GridViewDataTextColumn FieldName="用户号" Caption="用户号" Width="15%">
                                                        </dx:GridViewDataTextColumn>

                                                        <dx:GridViewDataTextColumn FieldName="用户名" Caption="用户名" Width="20%">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="年" Caption="水量年" Width="10%">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="月" Caption="水量月" Width="10%">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="抄表水量" Caption="抄表水量" Width="15%">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="开账水量" Caption="开账水量" Width="15%">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="开账金额" Caption="开账金额" Width="15%">
                                                        </dx:GridViewDataTextColumn>
                                                    </Columns>
                                                    <Settings VerticalScrollBarMode="Auto" HorizontalScrollBarMode="Auto" VerticalScrollableHeight="300 " />
                                                    <SettingsPager Mode="EndlessPaging" PageSize="1000" />
                                                    <Settings ShowFooter="True" />
                                                    <SettingsBehavior AllowFocusedRow="True"  ColumnResizeMode="Control" />
                                                    <SettingsBehavior ProcessFocusedRowChangedOnServer="False" />
                                                    <ClientSideEvents Init="function(s,e){AdjustSize(100,gvShenJingXX);}" />
                                                </dx:ASPxGridView>
                                            </div>
                                            <br />
                                            <div id="img">
                                                <table>
                                                    <tr>
                                                        <td>
                                                            <dx:ASPxLabel ID="zjl" Text="共0条" runat="server" ForeColor="Blue"></dx:ASPxLabel>
                                                        </td>
                                                    </tr>
                                                </table>
                                            </div>
                                            
                                        </div>

                                    </td>
                                </tr>
                        </table>

                    </div>
                </ContentTemplate>
            </asp:UpdatePanel>
        </div>
        
          <div style="display: none;">
            <dx:ASPxGridViewExporter ID="ASPxGridViewExporter1" runat="server"></dx:ASPxGridViewExporter>
            <dx:ASPxButton ID="btnExport" runat="server" ClientInstanceName="btnExport" Text="导出EXCEL" OnClick="btnExport_Click" UseSubmitBehavior="false">
            </dx:ASPxButton>
        </div>      
    </form>
</body>
</html>
